using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace SchemaProvider
{
    public interface ISchemaLoader
    {
        string ConnectionString
        {
            get;
            set;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        List<string> ListTableNames();

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        List<string> ListViewNames();

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        DataSet LoadTableSchemas();

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        DataSet LoadViewSchemas();

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        Dictionary<string, string> ListIdentities();

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        Dictionary<string, string> ListPrimaryKeys();


        /// <summary>
        /// 
        /// </summary>
        /// <param name="tableName"></param>
        /// <returns></returns>
        Dictionary<string, List<ForeignKey>> ListForeignKeys();


        /// <summary>
        /// 
        /// </summary>
        List<ProcedureParameter> ListProcedureParameters();

        void ShowAboutBox();
    }
}
